-
Re: Invalid Value Error on Dates (even when the column types are all DATE fields)
Here is another way of doing it that may be a little easier to modify. =IF([Affiliation Date]@row <> "", IFERROR(DATE(YEAR([Affiliation Date]@row), MONTH([Affiliation Date]@row) - 6, …1 · -
Re: Need a conditional formula to automate status column based on values in date columns
Another option would be along the lines of... =IF(ISDATE(End@row), "Complete", IF(ISDATE(Start@row), "In Progress", "Not Started"))1 · -
Re: Pause "Days in Progress" counter
Building off of the two date columns for on hold then off of hold, you could just do a basic subtraction of the two dates to get the duration of on hold and then subtract that from the final result o…1 · -
Re: Whats wrong with this nested if and vlookup formula?
Happy to help. 👍️ A quick tip: If you catch yourself repeating the same pieces of a formula over and over again with the only difference being a single variable based on an IF, you can nest the IF in…2 · -
Re: Please help with Parent-Child Circular references
Oh, Well there's the problem. You can't reference the column the formula is in. You have a number of options. The most simple would be to move the formula to a different column. If you are wanting to…1 ·